400
Can I change the format of date to be shown in the control

with List1 do
begin
	with Columns do
	begin
		Add('Default');
		with (IUnknown(Add('Format.1')) as EXLISTLib_TLB.Column) do
		begin
			ComputedField := '%0';
			FormatColumn := 'dateF(value) replace `/` with `-`';
		end;
		with (IUnknown(Add('Format.2')) as EXLISTLib_TLB.Column) do
		begin
			ComputedField := '%0';
			Def[EXLISTLib_TLB.exCaptionFormat] := OleVariant(1);
			FormatColumn := '`<b>`+ shortdate(value) + `</b> ` + timeF(value)';
		end;
		with (IUnknown(Add('Format.3')) as EXLISTLib_TLB.Column) do
		begin
			ComputedField := '%0';
			Def[EXLISTLib_TLB.exCaptionFormat] := OleVariant(1);
			FormatColumn := '( dateF(value) replace `/` with `-` ) + ` <b>`+ ( weekday(value) case ( 0 : `Su`; 1 : `Mo`; 2 : `Tu`; 3 : `We`; 4 : `Th`; 5 : `F' + 
	'r`; 6 : `Sa`) )';
		end;
	end;
	with Items do
	begin
		Add('1/1/2001 10:00:00 AM');
		Add('1/2/2001 10:00:00 AM');
	end;
end
399
How can I put a picture on the cell's background (method 3)

with List1 do
begin
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	VisualAppearance.Add(2,'CP:1 0 0 -164 0');
	with Columns do
	begin
		Add('column');
		with (IUnknown(Add('column')) as EXLISTLib_TLB.Column) do
		begin
			Alignment := EXLISTLib_TLB.CenterAlignment;
			HeaderAlignment := EXLISTLib_TLB.CenterAlignment;
		end;
	end;
	with Items do
	begin
		i := Add(Null);
		SelectableItem[i] := False;
		Caption[i,OleVariant(1)] := 'caption';
		CellBackColor[i,OleVariant(1)] := $2000000;
	end;
end
398
How can I put a picture on the cell's background (method 2)

with List1 do
begin
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	with Columns do
	begin
		Add('column');
		Add('column');
	end;
	with Items do
	begin
		i := Add(Null);
		SelectableItem[i] := False;
		Caption[i,OleVariant(1)] := 'caption';
		CellBackColor[i,OleVariant(1)] := $1000000;
		CellPicture[i,OleVariant(1)] := List1.ExecuteTemplate('loadpicture(`c:\exontrol\images\auction.gif`)');
		CellPictureWidth[i,OleVariant(1)] := 128;
		CellPictureHeight[i,OleVariant(1)] := List1.DefaultItemHeight;
	end;
end
397
How can I put a picture on the cell's background (method 1)

with List1 do
begin
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	with Columns do
	begin
		Add('column');
		with (IUnknown(Add('column')) as EXLISTLib_TLB.Column) do
		begin
			Alignment := EXLISTLib_TLB.CenterAlignment;
			HeaderAlignment := EXLISTLib_TLB.CenterAlignment;
		end;
	end;
	with Items do
	begin
		i := Add(Null);
		SelectableItem[i] := False;
		Caption[i,OleVariant(1)] := 'caption';
		CellBackColor[i,OleVariant(1)] := $1000000;
	end;
end
396
How do I access the cells, or how do I get the values in the columns

with List1 do
begin
	with Columns do
	begin
		Add('C1');
		Add('C2');
		Add('C3');
	end;
	with Items do
	begin
		h := Add('Item 1');
		Caption[h,OleVariant(1)] := 'SubItem 1.1';
		Caption[h,OleVariant(2)] := 'SubItem 1.2';
		OutputDebugString( Caption[h,OleVariant(2)] );
	end;
end
395
How can I apply the same ConditionalFormat on more than 1(one) column (multiple columns and not on item)

with List1 do
begin
	BeginUpdate();
	with ConditionalFormats.Add('1','K1') do
	begin
		BackColor := $ff;
		ApplyTo := EXLISTLib_TLB.FormatApplyToEnum($1);
	end;
	with ConditionalFormats.Add('1','K2') do
	begin
		BackColor := $ff;
		ApplyTo := EXLISTLib_TLB.FormatApplyToEnum($2);
	end;
	MarkSearchColumn := False;
	DrawGridLines := EXLISTLib_TLB.GridLinesEnum($fffffffc Or Integer(EXLISTLib_TLB.exVLines));
	with Columns do
	begin
		Add('Column 1');
		Add('Column 2');
		Add('Column 3');
	end;
	with Items do
	begin
		Add(Null);
		Add(Null);
		Add(Null);
	end;
	EndUpdate();
end
394
How can I get the list of items as they are displayed

with List1 do
begin
	BeginUpdate();
	BackColorAlternate := RGB(240,240,240);
	Columns.Add('Names');
	with Items do
	begin
		Add('Mantel');
		Add('Mechanik');
		Add('Motor');
		Add('Murks');
		Add('Märchen');
		Add('Möhren');
		Add('Mühle');
	end;
	Columns.Item[OleVariant(0)].SortOrder := EXLISTLib_TLB.SortAscending;
	EndUpdate();
	OutputDebugString( GetItems(OleVariant(1)) );
end
393
Is posible to reduce the size of the picture to be shown in the column's caption

with List1 do
begin
	BeginUpdate();
	HTMLPicture['pic1'] := 'c:\exontrol\images\zipdisk.gif';
	HeaderHeight := 48;
	(IUnknown(Columns.Add('DefaultSize')) as EXLISTLib_TLB.Column).HTMLCaption := 'Default-Size <img>pic1</img> Picture';
	(IUnknown(Columns.Add('CustomSize')) as EXLISTLib_TLB.Column).HTMLCaption := 'Custom-Size <img>pic1:16</img> Picture';
	EndUpdate();
end
392
How can I change the color, font, bold etc for the items/cells in the same column or for the entire column

with List1 do
begin
	BeginUpdate();
	MarkSearchColumn := False;
	with ConditionalFormats.Add('1',Null) do
	begin
		Bold := True;
		ForeColor := $ff;
		ApplyTo := EXLISTLib_TLB.FormatApplyToEnum($1);
	end;
	Columns.Add('C1');
	with (IUnknown(Columns.Add('C2')) as EXLISTLib_TLB.Column) do
	begin
		HeaderBold := True;
		HTMLCaption := '<fgcolor=FF0000>C2';
	end;
	with Items do
	begin
		Caption[Add(OleVariant(10)),OleVariant(1)] := OleVariant(11);
		Caption[Add(OleVariant(12)),OleVariant(1)] := OleVariant(13);
	end;
	EndUpdate();
end
391
Is it possible to limit the height of item while resizing the row

// AddItem event - Occurs after a new Item is inserted to Items collection.
procedure TForm1.List1AddItem(ASender: TObject; Item : Integer);
begin
	with List1 do
	begin
		Items.ItemMinHeight[Item] := 18;
		Items.ItemMaxHeight[Item] := 72;
	end
end;

with List1 do
begin
	BeginUpdate();
	ItemsAllowSizing := EXLISTLib_TLB.exResizeItem;
	ScrollBySingleLine := False;
	BackColorAlternate := RGB(240,240,240);
	Columns.Add('Names');
	with Items do
	begin
		Add('Mantel');
		Add('Mechanik');
		Add('Motor');
		Add('Murks');
		Add('Märchen');
		Add('Möhren');
		Add('Mühle');
	end;
	Columns.Item[OleVariant(0)].SortOrder := EXLISTLib_TLB.SortAscending;
	EndUpdate();
end
390
Can I specify un-sortable items so they keep their position once the user sorts the columns

with List1 do
begin
	(IUnknown(Columns.Add('Def')) as EXLISTLib_TLB.Column).SortType := EXLISTLib_TLB.SortNumeric;
	with Items do
	begin
		SortableItem[Add('Unsortable')] := False;
		Add(OleVariant(1));
		Add(OleVariant(2));
		Add(OleVariant(3));
	end;
end
389
The item is not getting selected when clicking the cell's checkbox. What should I do

// CellStateChanged event - Fired after cell's state is changed.
procedure TForm1.List1CellStateChanged(ASender: TObject; ItemIndex : Integer;ColIndex : Integer);
begin
	with List1 do
	begin
		Items.SelectItem[ItemIndex] := True;
	end
end;

with List1 do
begin
	(IUnknown(Columns.Add('Check')) as EXLISTLib_TLB.Column).Def[EXLISTLib_TLB.exCellHasCheckBox] := OleVariant(True);
	with Items do
	begin
		Add(OleVariant(0));
		Add(OleVariant(1));
		Add(OleVariant(2));
		Add(OleVariant(3));
	end;
end
388
Does your control supports multiple lines tooltip

with List1 do
begin
	HTMLPicture['pic1'] := 'c:\exontrol\images\zipdisk.gif';
	ToolTipDelay := 1;
	(IUnknown(Columns.Add('tootip')) as EXLISTLib_TLB.Column).ToolTip := '<br><font Tahoma;10>This</font> is a <b>multi-lines</b> tooltip assigned to a column. The tooltip supports built-in HTML tags, i' + 
	'cons and pictures.<br><br><br><img>pic1</img> picture ... <br><br>';
end
387
How can I prevent highlighting the column from the cursor - point

with List1 do
begin
	VisualAppearance.Add(1,'gBFLBCJwBAEHhEJAEGg4BI0IQAAYAQGKIYBkAKBQAGaAoDDUOQzQwAAxDKKUEwsACEIrjKCYVgOHYYRrIMYgBCMJhLEoaZLhEZRQiqDYtRDFQBSDDcPw/EaRZohGaYJg' + 
	'EgI=');
	Background[EXLISTLib_TLB.exCursorHoverColumn] := $1000000;
	(IUnknown(Columns.Add('S')) as EXLISTLib_TLB.Column).Width := 32;
	(IUnknown(Columns.Add('Level 1')) as EXLISTLib_TLB.Column).LevelKey := OleVariant(1);
	(IUnknown(Columns.Add('Level 2')) as EXLISTLib_TLB.Column).LevelKey := OleVariant(1);
	(IUnknown(Columns.Add('Level 3')) as EXLISTLib_TLB.Column).LevelKey := OleVariant(1);
	(IUnknown(Columns.Add('E1')) as EXLISTLib_TLB.Column).Width := 32;
	(IUnknown(Columns.Add('E2')) as EXLISTLib_TLB.Column).Width := 32;
	(IUnknown(Columns.Add('E3')) as EXLISTLib_TLB.Column).Width := 32;
	(IUnknown(Columns.Add('E4')) as EXLISTLib_TLB.Column).Width := 32;
end
386
Is there any option to show the tooltip programmatically

// MouseMove event - Occurs when the user moves the mouse.
procedure TForm1.List1MouseMove(ASender: TObject; Button : Smallint;Shift : Smallint;X : Integer;Y : Integer);
begin
	with List1 do
	begin
		ShowToolTip(ItemFromPoint[-1,-1,c,hit],'','8','8',Null);
	end
end;

with List1 do
begin
	BeginUpdate();
	Columns.Add('Def');
	with Items do
	begin
		Add('Item 1');
		Add('Item 2');
		Add('Item 3');
	end;
	EndUpdate();
end
385
Is it possible to prevent covering the colors by selected rows

with List1 do
begin
	SelBackMode := EXLISTLib_TLB.exTransparent;
	BackColorAlternate := RGB(240,240,240);
	Columns.Add('Column');
	with Items do
	begin
		Add('Item 1');
		Add('Item 2');
		Add('Item 3');
		Add('Item 4');
		Add('Item 5');
	end;
end
384
Can I use PNG images to display pictures in the control

with List1 do
begin
	HTMLPicture['pic1'] := 'c:\exontrol\images\card.png';
	HeaderHeight := 48;
	(IUnknown(Columns.Add('ColumnName')) as EXLISTLib_TLB.Column).HTMLCaption := '<b>HTML</b> Column <img>pic1</img> Picture';
end
383
Does your control support conditional format and computed fields

with List1 do
begin
	BeginUpdate();
	MarkSearchColumn := False;
	with ConditionalFormats do
	begin
		with Add('%1 >4',Null) do
		begin
			Bold := True;
			StrikeOut := True;
			ForeColor := $ff;
			ApplyTo := EXLISTLib_TLB.FormatApplyToEnum($1);
		end;
		with Add('%2 > 4',Null) do
		begin
			Bold := True;
			StrikeOut := True;
			ForeColor := $ff;
			ApplyTo := EXLISTLib_TLB.FormatApplyToEnum($2);
		end;
		with Add('%3 > 4',Null) do
		begin
			Bold := True;
			StrikeOut := True;
			ForeColor := $ff;
			ApplyTo := EXLISTLib_TLB.FormatApplyToEnum($3);
		end;
	end;
	with Columns do
	begin
		Add('Name');
		with (IUnknown(Add('A')) as EXLISTLib_TLB.Column) do
		begin
			SortType := EXLISTLib_TLB.SortNumeric;
			AllowSizing := False;
			Width := 36;
			FormatColumn := 'len(value) ? value + '' +''';
		end;
		with (IUnknown(Add('B')) as EXLISTLib_TLB.Column) do
		begin
			SortType := EXLISTLib_TLB.SortNumeric;
			AllowSizing := False;
			Width := 36;
			FormatColumn := 'len(value) ? value + '' +''';
		end;
		with (IUnknown(Add('C')) as EXLISTLib_TLB.Column) do
		begin
			SortType := EXLISTLib_TLB.SortNumeric;
			AllowSizing := False;
			Width := 36;
			FormatColumn := 'len(value) ? value + '' =''';
		end;
		with (IUnknown(Add('A+B+C')) as EXLISTLib_TLB.Column) do
		begin
			SortType := EXLISTLib_TLB.SortNumeric;
			AllowSizing := False;
			Width := 64;
			ComputedField := '%1+%2+%3';
			FormatColumn := '((0:=dbl(value)) < 10? ''<fgcolor=808080><font ;7>'' :''<b>'') + currency(=:0)';
			Def[EXLISTLib_TLB.exCaptionFormat] := OleVariant(1);
		end;
	end;
	with Items do
	begin
		h1 := Add('Item 1');
		Caption[h1,OleVariant(1)] := OleVariant(7);
		Caption[h1,OleVariant(2)] := OleVariant(3);
		Caption[h1,OleVariant(3)] := OleVariant(1);
		h1 := Add('Item 2');
		Caption[h1,OleVariant(1)] := OleVariant(2);
		Caption[h1,OleVariant(2)] := OleVariant(5);
		Caption[h1,OleVariant(3)] := OleVariant(12);
		h1 := Add('Item 3');
		Caption[h1,OleVariant(1)] := OleVariant(2);
		Caption[h1,OleVariant(2)] := OleVariant(2);
		Caption[h1,OleVariant(3)] := OleVariant(4);
		h1 := Add('Item 4');
		Caption[h1,OleVariant(1)] := OleVariant(2);
		Caption[h1,OleVariant(2)] := OleVariant(9);
		Caption[h1,OleVariant(3)] := OleVariant(4);
	end;
	EndUpdate();
end
382
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right

with List1 do
begin
	BeginUpdate();
	ScrollBars := EXLISTLib_TLB.DisableBoth;
	with Columns do
	begin
		Add('C1');
		Add('C2');
		Add('C3');
		Add('C4');
		Add('C5');
		Add('C6');
		Add('C7');
		Add('C8');
	end;
	RightToLeft := True;
	EndUpdate();
end
381
Can I display the cell's check box after the text

with List1 do
begin
	with (IUnknown(Columns.Add('Column')) as EXLISTLib_TLB.Column) do
	begin
		Def[EXLISTLib_TLB.exCellHasCheckBox] := OleVariant(True);
		Def[EXLISTLib_TLB.exCellDrawPartsOrder] := 'caption,check';
	end;
	with Items do
	begin
		CellHasCheckBox[Add('Caption 1'),OleVariant(0)] := True;
		CellHasCheckBox[Add('Caption 2'),OleVariant(0)] := True;
	end;
end
380
Can I change the order of the parts in the cell, as checkbox after the text, and so on

with List1 do
begin
	Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' + 
	'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' + 
	'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' + 
	'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
	(IUnknown(Columns.Add('Column')) as EXLISTLib_TLB.Column).Def[EXLISTLib_TLB.exCellDrawPartsOrder] := 'caption,check,icon,icons,picture';
	with Items do
	begin
		h := Add('Text');
		CellImage[h,OleVariant(0)] := 1;
		CellHasCheckBox[h,OleVariant(0)] := True;
	end;
end
379
Can I have an image displayed after the text. Can I get that effect without using HTML content

with List1 do
begin
	Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' + 
	'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' + 
	'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' + 
	'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
	(IUnknown(Columns.Add('Column')) as EXLISTLib_TLB.Column).Def[EXLISTLib_TLB.exCellDrawPartsOrder] := 'caption,icon,check,icons,picture';
	with Items do
	begin
		h := Add('Text');
		CellImage[h,OleVariant(0)] := 1;
	end;
end
378
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right

with List1 do
begin
	BeginUpdate();
	ScrollBars := EXLISTLib_TLB.DisableBoth;
	with Columns do
	begin
		Add('C1');
		Add('C2');
		Add('C3');
		Add('C4');
		Add('C5');
		Add('C6');
		Add('C7');
		Add('C8');
	end;
	RightToLeft := True;
	EndUpdate();
end
377
How can I change the foreground color for a particular column

with List1 do
begin
	with Columns do
	begin
		Add('Column 1');
		(IUnknown(Add('Column 2')) as EXLISTLib_TLB.Column).Def[EXLISTLib_TLB.exHeaderForeColor] := OleVariant(8439039);
		Add('Column 3');
	end;
end
376
How can I change the background color for a particular column

with List1 do
begin
	with Columns do
	begin
		Add('Column 1');
		(IUnknown(Add('Column 2')) as EXLISTLib_TLB.Column).Def[EXLISTLib_TLB.exHeaderBackColor] := OleVariant(8439039);
		Add('Column 3');
	end;
end
375
How can I display the column using currency format and enlarge the font for certain values

with List1 do
begin
	with (IUnknown(Columns.Add('Currency')) as EXLISTLib_TLB.Column) do
	begin
		Def[EXLISTLib_TLB.exCaptionFormat] := OleVariant(1);
		FormatColumn := 'len(value) ? ((0:=dbl(value)) < 10 ? ''<fgcolor=808080><font ;7>'' : ''<b>'') + currency(=:0)';
	end;
	with Items do
	begin
		Add('1.23');
		Add('2.34');
		Add('9.94');
		Add('11.94');
		Add('1000');
	end;
end
374
How can I highlight only parts of the cells

with List1 do
begin
	with (IUnknown(Columns.Add('')) as EXLISTLib_TLB.Column) do
	begin
		Def[EXLISTLib_TLB.exCaptionFormat] := OleVariant(1);
		FormatColumn := 'value replace ''hil'' with ''<fgcolor=FF0000><b>hil</b></fgcolor>''';
	end;
	with Items do
	begin
		h := Add('Root');
		Add('Child 1');
		Add('Child 2');
		Add('Child 3');
	end;
end
373
How can I get the number of occurrences of a specified string in the cell

with List1 do
begin
	Columns.Add('');
	with (IUnknown(Columns.Add('occurrences')) as EXLISTLib_TLB.Column) do
	begin
		ComputedField := 'lower(%0) count ''o''';
		FormatColumn := '''contains '' + value + '' of \''o\'' chars''';
	end;
	with Items do
	begin
		h := Add('Root');
		Add('Child 1 oooof the root');
		Add('Child 2');
		Add('Child 3');
	end;
end
372
How can I display dates in my format

with List1 do
begin
	with (IUnknown(Columns.Add('Date')) as EXLISTLib_TLB.Column) do
	begin
		Def[EXLISTLib_TLB.exCaptionFormat] := OleVariant(1);
		FormatColumn := '''<b>'' + year(0:=date(value)) + ''</b><fgcolor=808080><font ;6> ('' + month(=:0) + '' - '' + day(=:0) +'')''';
	end;
	with Items do
	begin
		Add('1/21/2001');
		Add('2/22/2002');
		Add('3/13/2003');
		Add('4/24/2004');
	end;
end
371
How can I display dates in short format

with List1 do
begin
	(IUnknown(Columns.Add('Date')) as EXLISTLib_TLB.Column).FormatColumn := 'shortdate(value)';
	with Items do
	begin
		Add('1/1/2001');
		Add('2/2/2002');
		Add('3/3/2003');
		Add('4/4/2004');
	end;
end
370
How can I display dates in long format

with List1 do
begin
	(IUnknown(Columns.Add('Date')) as EXLISTLib_TLB.Column).FormatColumn := 'longdate(value)';
	with Items do
	begin
		Add('1/1/2001');
		Add('2/2/2002');
		Add('3/3/2003');
		Add('4/4/2004');
	end;
end
369
How can I display only the right part of the cell

with List1 do
begin
	Columns.Add('');
	with (IUnknown(Columns.Add('Right')) as EXLISTLib_TLB.Column) do
	begin
		ComputedField := '%0 right 2';
		FormatColumn := '''"'' + value + ''"''';
	end;
	with Items do
	begin
		h := Add('Root');
		Add('Child 1');
		Add('Child 2');
		Add('SChild 3');
	end;
end
368
How can I display only the left part of the cell

with List1 do
begin
	Columns.Add('');
	(IUnknown(Columns.Add('Left')) as EXLISTLib_TLB.Column).ComputedField := '%0 left 2';
	with Items do
	begin
		h := Add('Root');
		Add('Child 1');
		Add('Child 2');
		Add('SChild 3');
	end;
end
367
How can I display true or false instead 0 and -1

with List1 do
begin
	(IUnknown(Columns.Add('Boolean')) as EXLISTLib_TLB.Column).FormatColumn := 'value != 0 ? ''true'' : ''false''';
	with Items do
	begin
		Add(OleVariant(True));
		Add(OleVariant(False));
		Add(OleVariant(True));
		Add(OleVariant(0));
		Add(OleVariant(1));
	end;
end
366
How can I display icons or images instead numbers

with List1 do
begin
	Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' + 
	'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' + 
	'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' + 
	'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
	with (IUnknown(Columns.Add('Icons')) as EXLISTLib_TLB.Column) do
	begin
		Def[EXLISTLib_TLB.exCaptionFormat] := OleVariant(1);
		FormatColumn := '''The cell displays the icon <img>''+value+''</img> instead '' + value';
	end;
	with Items do
	begin
		Add(OleVariant(1));
		Add(OleVariant(2));
		Add(OleVariant(3));
	end;
end
365
How can I display the column using currency

with List1 do
begin
	(IUnknown(Columns.Add('Currency')) as EXLISTLib_TLB.Column).FormatColumn := 'currency(dbl(value))';
	with Items do
	begin
		Add('1.23');
		Add('2.34');
		Add('0');
		Add(OleVariant(5));
		Add('10000.99');
	end;
end
364
Is is possible to use HTML tags to display in the filter caption

with List1 do
begin
	BeginUpdate();
	FilterBarPromptVisible := True;
	FilterBarCaption := 'This is a bit of text being displayed in the filter bar.';
	Columns.Add('');
	with Items do
	begin
		Add('Item 1');
		Add('Item 2');
		Add('Item 3');
	end;
	EndUpdate();
end
363
How can I find the number of items after filtering
with List1 do
begin
	BeginUpdate();
	Columns.Add('');
	with Items do
	begin
		h := Add('');
		Caption[h,OleVariant(0)] := OleVariant(VisibleItemCount);
	end;
	EndUpdate();
end
362
How can I change the filter caption

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	FilterBarPromptType := Integer(EXLISTLib_TLB.exFilterPromptWords) Or Integer(EXLISTLib_TLB.exFilterPromptContainsAll);
	FilterBarPromptPattern := 'london robert';
	FilterBarCaption := '<r>Found: ... ';
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	with Items do
	begin
		h0 := Add('Nancy Davolio');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Andrew Fuller');
		Caption[h0,OleVariant(1)] := 'Vice President, Sales';
		Caption[h0,OleVariant(2)] := 'Tacoma';
		SelectItem[h0] := True;
		h0 := Add('Janet Leverling');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Kirkland';
		h0 := Add('Margaret Peacock');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Redmond';
		h0 := Add('Steven Buchanan');
		Caption[h0,OleVariant(1)] := 'Sales Manager';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Michael Suyama');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Robert King');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Laura Callahan');
		Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Anne Dodsworth');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
	end;
	EndUpdate();
end
361
While using the filter prompt is it is possible to use wild characters

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	FilterBarPromptType := EXLISTLib_TLB.exFilterPromptPattern;
	FilterBarPromptPattern := 'lon* seat*';
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	with Items do
	begin
		h0 := Add('Nancy Davolio');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Andrew Fuller');
		Caption[h0,OleVariant(1)] := 'Vice President, Sales';
		Caption[h0,OleVariant(2)] := 'Tacoma';
		SelectItem[h0] := True;
		h0 := Add('Janet Leverling');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Kirkland';
		h0 := Add('Margaret Peacock');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Redmond';
		h0 := Add('Steven Buchanan');
		Caption[h0,OleVariant(1)] := 'Sales Manager';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Michael Suyama');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Robert King');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Laura Callahan');
		Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Anne Dodsworth');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
	end;
	EndUpdate();
end
360
How can I list all items that contains any of specified words, not necessary at the beggining

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	FilterBarPromptType := Integer(EXLISTLib_TLB.exFilterPromptStartWords) Or Integer(EXLISTLib_TLB.exFilterPromptContainsAny);
	FilterBarPromptPattern := 'london davolio';
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	with Items do
	begin
		h0 := Add('Nancy Davolio');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Andrew Fuller');
		Caption[h0,OleVariant(1)] := 'Vice President, Sales';
		Caption[h0,OleVariant(2)] := 'Tacoma';
		SelectItem[h0] := True;
		h0 := Add('Janet Leverling');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Kirkland';
		h0 := Add('Margaret Peacock');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Redmond';
		h0 := Add('Steven Buchanan');
		Caption[h0,OleVariant(1)] := 'Sales Manager';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Michael Suyama');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Robert King');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Laura Callahan');
		Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Anne Dodsworth');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
	end;
	EndUpdate();
end
359
How can I list all items that contains any of specified words, not strings

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	FilterBarPromptType := Integer(EXLISTLib_TLB.exFilterPromptWords) Or Integer(EXLISTLib_TLB.exFilterPromptContainsAny);
	FilterBarPromptPattern := 'london nancy';
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	with Items do
	begin
		h0 := Add('Nancy Davolio');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Andrew Fuller');
		Caption[h0,OleVariant(1)] := 'Vice President, Sales';
		Caption[h0,OleVariant(2)] := 'Tacoma';
		SelectItem[h0] := True;
		h0 := Add('Janet Leverling');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Kirkland';
		h0 := Add('Margaret Peacock');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Redmond';
		h0 := Add('Steven Buchanan');
		Caption[h0,OleVariant(1)] := 'Sales Manager';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Michael Suyama');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Robert King');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Laura Callahan');
		Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Anne Dodsworth');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
	end;
	EndUpdate();
end
358
How can I list all items that contains all specified words, not strings

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	FilterBarPromptType := Integer(EXLISTLib_TLB.exFilterPromptWords) Or Integer(EXLISTLib_TLB.exFilterPromptContainsAll);
	FilterBarPromptPattern := 'london robert';
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	with Items do
	begin
		h0 := Add('Nancy Davolio');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Andrew Fuller');
		Caption[h0,OleVariant(1)] := 'Vice President, Sales';
		Caption[h0,OleVariant(2)] := 'Tacoma';
		SelectItem[h0] := True;
		h0 := Add('Janet Leverling');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Kirkland';
		h0 := Add('Margaret Peacock');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Redmond';
		h0 := Add('Steven Buchanan');
		Caption[h0,OleVariant(1)] := 'Sales Manager';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Michael Suyama');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Robert King');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Laura Callahan');
		Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Anne Dodsworth');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
	end;
	EndUpdate();
end
357
I've noticed that the filtering by prompt is not case sensitive, is is possible to make it case sensitive

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	FilterBarPromptType := Integer(EXLISTLib_TLB.exFilterPromptCaseSensitive) Or Integer(EXLISTLib_TLB.exFilterPromptContainsAny);
	FilterBarPromptPattern := 'Anne';
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	with Items do
	begin
		h0 := Add('Nancy Davolio');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Andrew Fuller');
		Caption[h0,OleVariant(1)] := 'Vice President, Sales';
		Caption[h0,OleVariant(2)] := 'Tacoma';
		SelectItem[h0] := True;
		h0 := Add('Janet Leverling');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Kirkland';
		h0 := Add('Margaret Peacock');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Redmond';
		h0 := Add('Steven Buchanan');
		Caption[h0,OleVariant(1)] := 'Sales Manager';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Michael Suyama');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Robert King');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Laura Callahan');
		Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Anne Dodsworth');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
	end;
	EndUpdate();
end
356
Is it possible to list only items that ends with any of specified strings

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	FilterBarPromptType := EXLISTLib_TLB.exFilterPromptEndWith;
	FilterBarPromptColumns := '0';
	FilterBarPromptPattern := 'Fuller';
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	with Items do
	begin
		h0 := Add('Nancy Davolio');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Andrew Fuller');
		Caption[h0,OleVariant(1)] := 'Vice President, Sales';
		Caption[h0,OleVariant(2)] := 'Tacoma';
		SelectItem[h0] := True;
		h0 := Add('Janet Leverling');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Kirkland';
		h0 := Add('Margaret Peacock');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Redmond';
		h0 := Add('Steven Buchanan');
		Caption[h0,OleVariant(1)] := 'Sales Manager';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Michael Suyama');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Robert King');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Laura Callahan');
		Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Anne Dodsworth');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
	end;
	EndUpdate();
end
355
Is it possible to list only items that ends with any of specified strings

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	FilterBarPromptType := EXLISTLib_TLB.exFilterPromptEndWith;
	FilterBarPromptColumns := '0';
	FilterBarPromptPattern := 'Fuller';
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	with Items do
	begin
		h0 := Add('Nancy Davolio');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Andrew Fuller');
		Caption[h0,OleVariant(1)] := 'Vice President, Sales';
		Caption[h0,OleVariant(2)] := 'Tacoma';
		SelectItem[h0] := True;
		h0 := Add('Janet Leverling');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Kirkland';
		h0 := Add('Margaret Peacock');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Redmond';
		h0 := Add('Steven Buchanan');
		Caption[h0,OleVariant(1)] := 'Sales Manager';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Michael Suyama');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Robert King');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Laura Callahan');
		Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Anne Dodsworth');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
	end;
	EndUpdate();
end
354
Is it possible to list only items that starts with any of specified strings

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	FilterBarPromptType := EXLISTLib_TLB.exFilterPromptStartWith;
	FilterBarPromptColumns := '0';
	FilterBarPromptPattern := 'An M';
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	with Items do
	begin
		h0 := Add('Nancy Davolio');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Andrew Fuller');
		Caption[h0,OleVariant(1)] := 'Vice President, Sales';
		Caption[h0,OleVariant(2)] := 'Tacoma';
		SelectItem[h0] := True;
		h0 := Add('Janet Leverling');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Kirkland';
		h0 := Add('Margaret Peacock');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Redmond';
		h0 := Add('Steven Buchanan');
		Caption[h0,OleVariant(1)] := 'Sales Manager';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Michael Suyama');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Robert King');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Laura Callahan');
		Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Anne Dodsworth');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
	end;
	EndUpdate();
end
353
Is it possible to list only items that starts with specified string

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	FilterBarPromptType := EXLISTLib_TLB.exFilterPromptStartWith;
	FilterBarPromptColumns := '0';
	FilterBarPromptPattern := 'A';
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	with Items do
	begin
		h0 := Add('Nancy Davolio');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Andrew Fuller');
		Caption[h0,OleVariant(1)] := 'Vice President, Sales';
		Caption[h0,OleVariant(2)] := 'Tacoma';
		SelectItem[h0] := True;
		h0 := Add('Janet Leverling');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Kirkland';
		h0 := Add('Margaret Peacock');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Redmond';
		h0 := Add('Steven Buchanan');
		Caption[h0,OleVariant(1)] := 'Sales Manager';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Michael Suyama');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Robert King');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Laura Callahan');
		Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Anne Dodsworth');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
	end;
	EndUpdate();
end
352
How can I specify that the list should include any of the seqeunces in the pattern

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	FilterBarPromptType := EXLISTLib_TLB.exFilterPromptContainsAny;
	FilterBarPromptPattern := 'london seattle';
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	with Items do
	begin
		h0 := Add('Nancy Davolio');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Andrew Fuller');
		Caption[h0,OleVariant(1)] := 'Vice President, Sales';
		Caption[h0,OleVariant(2)] := 'Tacoma';
		SelectItem[h0] := True;
		h0 := Add('Janet Leverling');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Kirkland';
		h0 := Add('Margaret Peacock');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Redmond';
		h0 := Add('Steven Buchanan');
		Caption[h0,OleVariant(1)] := 'Sales Manager';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Michael Suyama');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Robert King');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Laura Callahan');
		Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Anne Dodsworth');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
	end;
	EndUpdate();
end
351
How can I specify that all sequences in the filter pattern must be included in the list

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	FilterBarPromptType := EXLISTLib_TLB.exFilterPromptContainsAll;
	FilterBarPromptPattern := 'london manager';
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	with Items do
	begin
		h0 := Add('Nancy Davolio');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Andrew Fuller');
		Caption[h0,OleVariant(1)] := 'Vice President, Sales';
		Caption[h0,OleVariant(2)] := 'Tacoma';
		SelectItem[h0] := True;
		h0 := Add('Janet Leverling');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Kirkland';
		h0 := Add('Margaret Peacock');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Redmond';
		h0 := Add('Steven Buchanan');
		Caption[h0,OleVariant(1)] := 'Sales Manager';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Michael Suyama');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Robert King');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Laura Callahan');
		Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Anne Dodsworth');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
	end;
	EndUpdate();
end
350
How do I change at runtime the filter prompt

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	FilterBarPromptPattern := 'london manager';
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	with Items do
	begin
		h0 := Add('Nancy Davolio');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Andrew Fuller');
		Caption[h0,OleVariant(1)] := 'Vice President, Sales';
		Caption[h0,OleVariant(2)] := 'Tacoma';
		SelectItem[h0] := True;
		h0 := Add('Janet Leverling');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Kirkland';
		h0 := Add('Margaret Peacock');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Redmond';
		h0 := Add('Steven Buchanan');
		Caption[h0,OleVariant(1)] := 'Sales Manager';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Michael Suyama');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Robert King');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Laura Callahan');
		Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Anne Dodsworth');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
	end;
	EndUpdate();
end
349
How do I specify to filter only a single column when using the filter prompt

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	FilterBarPromptColumns := '2,3';
	FilterBarPromptPattern := 'london';
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	with Items do
	begin
		h0 := Add('Nancy Davolio');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Andrew Fuller');
		Caption[h0,OleVariant(1)] := 'Vice President, Sales';
		Caption[h0,OleVariant(2)] := 'Tacoma';
		SelectItem[h0] := True;
		h0 := Add('Janet Leverling');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Kirkland';
		h0 := Add('Margaret Peacock');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Redmond';
		h0 := Add('Steven Buchanan');
		Caption[h0,OleVariant(1)] := 'Sales Manager';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Michael Suyama');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Robert King');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Laura Callahan');
		Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Anne Dodsworth');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
	end;
	EndUpdate();
end
348
How do I change the prompt or the caption being displayed in the filter bar

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	FilterBarPrompt := 'changed';
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	EndUpdate();
end
347
How do I enable the filter prompt feature

with List1 do
begin
	BeginUpdate();
	ColumnAutoResize := True;
	ContinueColumnScroll := False;
	MarkSearchColumn := False;
	SearchColumnIndex := 1;
	FilterBarPromptVisible := True;
	with Columns do
	begin
		(IUnknown(Add('Name')) as EXLISTLib_TLB.Column).Width := 96;
		(IUnknown(Add('Title')) as EXLISTLib_TLB.Column).Width := 96;
		Add('City');
	end;
	with Items do
	begin
		h0 := Add('Nancy Davolio');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Andrew Fuller');
		Caption[h0,OleVariant(1)] := 'Vice President, Sales';
		Caption[h0,OleVariant(2)] := 'Tacoma';
		SelectItem[h0] := True;
		h0 := Add('Janet Leverling');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Kirkland';
		h0 := Add('Margaret Peacock');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'Redmond';
		h0 := Add('Steven Buchanan');
		Caption[h0,OleVariant(1)] := 'Sales Manager';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Michael Suyama');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Robert King');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
		h0 := Add('Laura Callahan');
		Caption[h0,OleVariant(1)] := 'Inside Sales Coordinator';
		Caption[h0,OleVariant(2)] := 'Seattle';
		h0 := Add('Anne Dodsworth');
		Caption[h0,OleVariant(1)] := 'Sales Representative';
		Caption[h0,OleVariant(2)] := 'London';
	end;
	EndUpdate();
end
346
Is it possible to change the style for the vertical or horizontal grid lines, in the list area

with List1 do
begin
	BeginUpdate();
	DrawGridLines := EXLISTLib_TLB.exAllLines;
	GridLineStyle := Integer(EXLISTLib_TLB.exGridLinesVSolid) Or Integer(EXLISTLib_TLB.exGridLinesHDot4);
	Columns.Add('C1');
	Columns.Add('C2');
	Columns.Add('C3');
	with Items do
	begin
		h := Add('Item 1');
		Caption[h,OleVariant(1)] := 'SubItem 1.2';
		Caption[h,OleVariant(2)] := 'SubItem 1.3';
		h := Add('Item 2');
		Caption[h,OleVariant(1)] := 'SubItem 2.2';
		Caption[h,OleVariant(2)] := 'SubItem 2.3';
	end;
	EndUpdate();
end
345
Is it possible to change the style for the grid lines, for instance to be solid not dotted

with List1 do
begin
	BeginUpdate();
	DrawGridLines := EXLISTLib_TLB.exAllLines;
	GridLineStyle := EXLISTLib_TLB.exGridLinesSolid;
	Columns.Add('Column');
	EndUpdate();
end
344
How can I filter programatically using more columns

with List1 do
begin
	BeginUpdate();
	MarkSearchColumn := False;
	with Columns do
	begin
		Add('Car');
		Add('Equipment');
	end;
	with Items do
	begin
		Caption[Add('Mazda'),OleVariant(1)] := 'Air Bag';
		Caption[Add('Toyota'),OleVariant(1)] := 'Air Bag,Air condition';
		Caption[Add('Ford'),OleVariant(1)] := 'Air condition';
		Caption[Add('Nissan'),OleVariant(1)] := 'Air Bag,ABS,ESP';
		Caption[Add('Mazda'),OleVariant(1)] := 'Air Bag, ABS,ESP';
		Caption[Add('Mazda'),OleVariant(1)] := 'ABS,ESP';
	end;
	with Columns.Item['Car'] do
	begin
		FilterType := EXLISTLib_TLB.exFilter;
		Filter := 'Mazda';
	end;
	with Columns.Item['Equipment'] do
	begin
		FilterType := EXLISTLib_TLB.exPattern;
		Filter := '*ABS*|*ESP*';
	end;
	ApplyFilter();
	EndUpdate();
end
343
How do I find an item based on my extra data

with List1 do
begin
	Columns.Add('Default');
	with Items do
	begin
		Add('Item 1');
		Add('Item 2');
		ItemData[Add('Item 3')] := OleVariant(1234);
		Add('Item 4');
		ItemBold[FindItemData[OleVariant(1234),Null]] := True;
	end;
end
342
How do I print the control's content

with List1 do
begin
	BeginUpdate();
	Columns.Add('Number');
	(IUnknown(Columns.Add('Currency')) as EXLISTLib_TLB.Column).ComputedField := 'len(%0) ? currency(dbl(%0)) : ''''';
	with Items do
	begin
		Add('1.23');
		Add('2.34');
		Add('0');
		ItemBackColor[Add(Null)] := $8080ff;
		Add('10000.99');
	end;
	EndUpdate();
	with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print'))) as EXPRINTLib_TLB.Print) do
	begin
		PrintExt := (IUnknown(List1.DefaultInterface) as EXLISTLib_TLB.List);
		Preview();
	end;
end
341
How can I display the currency only for not empty cells
with List1 do
begin
	Columns.Add('Number');
	(IUnknown(Columns.Add('Currency')) as EXLISTLib_TLB.Column).ComputedField := 'len(%0) ? currency(dbl(%0)) : ''''';
	with Items do
	begin
		Add('1.23');
		Add('2.34');
		Add('0');
		ItemBackColor[Add(Null)] := $8080ff;
		Add('10000.99');
	end;
end
340
Is there a function to display the number of days between two date including the number of hours

with List1 do
begin
	(IUnknown(Columns.Add('Start')) as EXLISTLib_TLB.Column).Width := 32;
	Columns.Add('End');
	(IUnknown(Columns.Add('Duration')) as EXLISTLib_TLB.Column).ComputedField := '2:=((1:=int(0:= date(%1)-date(%0))) = 0 ? '''' : str(=:1) + '' day(s)'') + ( 3:=round(24*(=:0-floor(=:0))) ? (len(=:2) ? '' and '' : ''' + 
	''') + =:3 + '' hour(s)'' : '''' )';
	with Items do
	begin
		h := Add('1/11/2001');
		Caption[h,OleVariant(1)] := '1/14/2001';
		h := Add('2/22/2002 12:00:00 PM');
		Caption[h,OleVariant(1)] := '3/14/2002 1:00:00 PM';
		h := Add('3/13/2003');
		Caption[h,OleVariant(1)] := '4/11/2003 11:00:00 AM';
	end;
end
339
Is there a function to display the number of days between two date including the number of hours

with List1 do
begin
	Columns.Add('Start');
	Columns.Add('End');
	(IUnknown(Columns.Add('Duration')) as EXLISTLib_TLB.Column).ComputedField := '"D " + int(date(%1)-date(%0)) + " H " + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%0))))';
	with Items do
	begin
		h := Add('1/11/2001');
		Caption[h,OleVariant(1)] := '1/14/2001 11:00:00 PM';
		h := Add('2/22/2002 12:00:00 PM');
		Caption[h,OleVariant(1)] := '3/14/2002 1:00:00 PM';
		h := Add('3/13/2003');
		Caption[h,OleVariant(1)] := '4/11/2003 11:00:00 AM';
	end;
end
338
How can I display the number of days between two dates

with List1 do
begin
	Columns.Add('Start');
	Columns.Add('End');
	(IUnknown(Columns.Add('Duration')) as EXLISTLib_TLB.Column).ComputedField := '(date(%1)-date(%0)) + '' days''';
	with Items do
	begin
		h := Add('1/11/2001');
		Caption[h,OleVariant(1)] := '1/14/2001';
		h := Add('2/22/2002');
		Caption[h,OleVariant(1)] := '3/14/2002';
		h := Add('3/13/2003');
		Caption[h,OleVariant(1)] := '4/11/2003';
	end;
end
337
How can I get second part of the date

with List1 do
begin
	Columns.Add('Date');
	(IUnknown(Columns.Add('Second')) as EXLISTLib_TLB.Column).ComputedField := 'sec(date(%0))';
	with Items do
	begin
		Add('1/11/2001 10:10:00 AM');
		Add('2/22/2002 11:01:22 AM');
		Add('3/13/2003 12:23:01 PM');
		Add('4/14/2004 1:11:59 PM');
	end;
end
336
How can I get minute part of the date

with List1 do
begin
	Columns.Add('Date');
	(IUnknown(Columns.Add('Minute')) as EXLISTLib_TLB.Column).ComputedField := 'min(date(%0))';
	with Items do
	begin
		Add('1/11/2001 10:10:00 AM');
		Add('2/22/2002 11:01:00 AM');
		Add('3/13/2003 12:23:00 PM');
		Add('4/14/2004 1:11:00 PM');
	end;
end
335
How can I check the hour part only so I know it was afternoon

with List1 do
begin
	ConditionalFormats.Add('hour(%0)>=12',Null).Bold := True;
	Columns.Add('Date');
	(IUnknown(Columns.Add('Hour')) as EXLISTLib_TLB.Column).ComputedField := 'hour(%0)';
	with Items do
	begin
		Add('1/11/2001 10:00:00 AM');
		Add('2/22/2002 11:00:00 AM');
		Add('3/13/2003 12:00:00 PM');
		Add('4/14/2004 1:00:00 PM');
	end;
end
334
What about a function to get the day in the week, or days since Sunday

with List1 do
begin
	Columns.Add('Date');
	(IUnknown(Columns.Add('WeekDay')) as EXLISTLib_TLB.Column).ComputedField := 'weekday(%0)';
	with Items do
	begin
		Add('1/11/2001 10:00:00 AM');
		Add('2/22/2002 11:00:00 AM');
		Add('3/13/2003 12:00:00 PM');
		Add('4/14/2004 1:00:00 PM');
	end;
end
333
Is there any function to get the day of the year or number of days since January 1st

with List1 do
begin
	Columns.Add('Date');
	(IUnknown(Columns.Add('Day since January 1st')) as EXLISTLib_TLB.Column).ComputedField := 'yearday(%0)';
	with Items do
	begin
		Add('1/11/2001 10:00:00 AM');
		Add('2/22/2002 11:00:00 AM');
		Add('3/13/2003 12:00:00 PM');
		Add('4/14/2004 1:00:00 PM');
	end;
end
332
How can I display only the day of the date

with List1 do
begin
	Columns.Add('Date');
	(IUnknown(Columns.Add('Day')) as EXLISTLib_TLB.Column).ComputedField := 'day(%0)';
	with Items do
	begin
		Add('1/11/2001 10:00:00 AM');
		Add('2/22/2002 11:00:00 AM');
		Add('3/13/2003 12:00:00 PM');
		Add('4/14/2004 1:00:00 PM');
	end;
end
331
How can I display only the month of the date

with List1 do
begin
	Columns.Add('Date');
	(IUnknown(Columns.Add('Month')) as EXLISTLib_TLB.Column).ComputedField := 'month(%0)';
	with Items do
	begin
		Add('1/1/2001 10:00:00 AM');
		Add('2/2/2002 11:00:00 AM');
		Add('3/3/2003 12:00:00 PM');
		Add('4/4/2004 1:00:00 PM');
	end;
end
330
How can I get only the year part from a date expression

with List1 do
begin
	Columns.Add('Date');
	(IUnknown(Columns.Add('Year')) as EXLISTLib_TLB.Column).ComputedField := 'year(%0)';
	with Items do
	begin
		Add('1/1/2001 10:00:00 AM');
		Add('2/2/2002 11:00:00 AM');
		Add('3/3/2003 12:00:00 PM');
		Add('4/4/2004 1:00:00 PM');
	end;
end
329
Can I convert the expression to date

with List1 do
begin
	Columns.Add('Number');
	(IUnknown(Columns.Add('Date')) as EXLISTLib_TLB.Column).ComputedField := 'date(dbl(%0))';
	with Items do
	begin
		Add('-1.98');
		Add('30000.99');
		Add('3561.23');
		Add('1232.34');
	end;
end
328
Can I convert the expression to a number, double or float

with List1 do
begin
	Columns.Add('Number');
	(IUnknown(Columns.Add('Number + 2')) as EXLISTLib_TLB.Column).ComputedField := 'dbl(%0)+2';
	with Items do
	begin
		Add('-1.98');
		Add('0.99');
		Add('1.23');
		Add('2.34');
	end;
end
327
How can I display dates in long format

with List1 do
begin
	Columns.Add('Date');
	(IUnknown(Columns.Add('LongFormat')) as EXLISTLib_TLB.Column).ComputedField := 'longdate(%0)';
	with Items do
	begin
		Add('1/1/2001 10:00:00 AM');
		Add('2/2/2002 11:00:00 AM');
		Add('3/3/2003 12:00:00 PM');
		Add('4/4/2004 1:00:00 PM');
	end;
end
326
How can I display dates in short format

with List1 do
begin
	Columns.Add('Date');
	(IUnknown(Columns.Add('ShortFormat')) as EXLISTLib_TLB.Column).ComputedField := 'shortdate(%0)';
	with Items do
	begin
		Add('1/1/2001 10:00:00 AM');
		Add('2/2/2002 11:00:00 AM');
		Add('3/3/2003 12:00:00 PM');
		Add('4/4/2004 1:00:00 PM');
	end;
end
325
How can I display the time only of a date expression

with List1 do
begin
	Columns.Add('Date');
	(IUnknown(Columns.Add('Time')) as EXLISTLib_TLB.Column).ComputedField := '''time is:'' + time(date(%0))';
	with Items do
	begin
		Add('1/1/2001 10:00:00 AM');
		Add('2/2/2002 11:00:00 AM');
		Add('3/3/2003 12:00:00 PM');
		Add('4/4/2004 1:00:00 PM');
	end;
end
324
Is there any function to display currencies, or money formatted as in the control panel

with List1 do
begin
	Columns.Add('Number');
	(IUnknown(Columns.Add('Currency')) as EXLISTLib_TLB.Column).ComputedField := 'currency(dbl(%0))';
	with Items do
	begin
		Add('1.23');
		Add('2.34');
		Add('10000.99');
	end;
end
323
How can I convert the expression to a string so I can look into the date string expression for month's name

with List1 do
begin
	Columns.Add('Number');
	(IUnknown(Columns.Add('Str')) as EXLISTLib_TLB.Column).ComputedField := 'str(%0) + '' AA''';
	with Items do
	begin
		Add('-1.98');
		Add('0.99');
		Add('1.23');
		Add('2.34');
	end;
end
322
Can I display the absolute value or positive part of the number

with List1 do
begin
	Columns.Add('Number');
	(IUnknown(Columns.Add('Abs')) as EXLISTLib_TLB.Column).ComputedField := 'abs(%0)';
	with Items do
	begin
		Add('-1.98');
		Add('0.99');
		Add('1.23');
		Add('2.34');
	end;
end
321
Is there any function to get largest number with no fraction part that is not greater than the value

with List1 do
begin
	Columns.Add('Number');
	(IUnknown(Columns.Add('Floor')) as EXLISTLib_TLB.Column).ComputedField := 'floor(%0)';
	with Items do
	begin
		Add('-1.98');
		Add('0.99');
		Add('1.23');
		Add('2.34');
	end;
end
320
Is there any function to round the values base on the .5 value

with List1 do
begin
	Columns.Add('Number');
	(IUnknown(Columns.Add('Round')) as EXLISTLib_TLB.Column).ComputedField := 'round(%0)';
	with Items do
	begin
		Add('-1.98');
		Add('0.99');
		Add('1.23');
		Add('2.34');
	end;
end
319
How can I get or display the integer part of the cell

with List1 do
begin
	Columns.Add('Number');
	(IUnknown(Columns.Add('Int')) as EXLISTLib_TLB.Column).ComputedField := 'int(%0)';
	with Items do
	begin
		Add('-1.98');
		Add('0.99');
		Add('1.23');
		Add('2.34');
	end;
end
318
How can I display names as proper ( first leter of the word must be in uppercase, and the rest in lowercase )

with List1 do
begin
	(IUnknown(Columns.Add('')) as EXLISTLib_TLB.Column).ComputedField := 'proper(%0)';
	with Items do
	begin
		h := Add('Item 1');
		Add('item item');
		Add('item item');
		Add('item item');
	end;
end
317
Is there any option to display cells in uppercase

with List1 do
begin
	(IUnknown(Columns.Add('')) as EXLISTLib_TLB.Column).ComputedField := 'upper(%0)';
	with Items do
	begin
		h := Add('Item 1');
		Add('Item 2');
		Add('Item 3');
		Add('Item 4 - child');
	end;
end
316
Is there any option to display cells in lowercase

with List1 do
begin
	(IUnknown(Columns.Add('')) as EXLISTLib_TLB.Column).ComputedField := 'lower(%0)';
	with Items do
	begin
		h := Add('Item 1');
		Add('Item 2');
		Add('Item 3');
		Add('Item 4 - child');
	end;
end
315
How can I mark the cells that has a specified type, ie strings only

with List1 do
begin
	ConditionalFormats.Add('type(%0) = 8',Null).ForeColor := $ff;
	Columns.Add('');
	with Items do
	begin
		h := Add('Item 1');
		Add('Item 2');
		Add(OleVariant(2));
		Add('Item 4 - child');
	end;
end
314
How can I bold the items that contains data or those who displays empty strings

with List1 do
begin
	ConditionalFormats.Add('not len(%1)=0',Null).Bold := True;
	Columns.Add('C1');
	Columns.Add('C2');
	with Items do
	begin
		h := Add('Item 1');
		Add('Item 2');
		hC := Add('Item 3');
		Caption[hC,OleVariant(1)] := '1';
		Add('Item 3');
	end;
end
313
Can I change the background color for items or cells that contains a specified string

with List1 do
begin
	ConditionalFormats.Add('%0 contains ''hi''',Null).BackColor := $ff;
	Columns.Add('');
	with Items do
	begin
		Add('Item 1');
		Add('Item 2');
		Add('Item 3');
		Add('Item 4 - child');
	end;
end
312
Is there any option to change the fore color for cells or items that ends with a specified string

with List1 do
begin
	ConditionalFormats.Add('%0 endwith ''22''',Null).ForeColor := $ff;
	Columns.Add('');
	with Items do
	begin
		Add('Item 1');
		Add('Item 2');
		Add('Item 1.22');
		Add('Item 2.22');
	end;
end
311
How can I highlight the cells or items that starts with a specified string

with List1 do
begin
	ConditionalFormats.Add('%0 startwith ''C''',Null).Underline := True;
	Columns.Add('');
	with Items do
	begin
		Add('Item 1');
		Add('CItem 2');
		Add('Item 3');
		Add('Item 4');
	end;
end
310
How can I change the foreground color for a particular column

with List1 do
begin
	with Columns do
	begin
		Add('Column 1');
		(IUnknown(Add('Column 2')) as EXLISTLib_TLB.Column).Def[EXLISTLib_TLB.exHeaderForeColor] := OleVariant(8439039);
		Add('Column 3');
	end;
end
309
How can I change the background color for a particular column

with List1 do
begin
	with Columns do
	begin
		Add('Column 1');
		(IUnknown(Add('Column 2')) as EXLISTLib_TLB.Column).Def[EXLISTLib_TLB.exHeaderBackColor] := OleVariant(8439039);
		Add('Column 3');
	end;
end
308
How can I display the column's header using multiple lines

with List1 do
begin
	HeaderHeight := 128;
	HeaderSingleLine := False;
	(IUnknown(Columns.Add('This is just a column that should break the header.')) as EXLISTLib_TLB.Column).Width := 32;
	Columns.Add('This is just another column that should break the header.');
end
307
How can I align the text/caption on the scroll bar

with List1 do
begin
	ScrollPartCaption[EXLISTLib_TLB.exHScroll,EXLISTLib_TLB.exLowerBackPart] := 'left';
	ScrollPartCaptionAlignment[EXLISTLib_TLB.exHScroll,EXLISTLib_TLB.exLowerBackPart] := EXLISTLib_TLB.LeftAlignment;
	ScrollPartCaption[EXLISTLib_TLB.exHScroll,EXLISTLib_TLB.exUpperBackPart] := 'right';
	ScrollPartCaptionAlignment[EXLISTLib_TLB.exHScroll,EXLISTLib_TLB.exUpperBackPart] := EXLISTLib_TLB.RightAlignment;
	ColumnAutoResize := False;
	Columns.Add(1);
	Columns.Add(2);
	Columns.Add(3);
	Columns.Add(4);
	Columns.Add(5);
	Columns.Add(6);
end
306
How do I select the next row/item

with List1 do
begin
	Columns.Add('Column');
	with Items do
	begin
		Add('Item 1');
		Add('Item 2');
		Add('Item 3');
		SelectItem[NextVisibleItem[FocusItem]] := True;
	end;
end
305
How do I enable resizing ( changing the height ) the items at runtime

with List1 do
begin
	ItemsAllowSizing := EXLISTLib_TLB.exResizeItem;
	DrawGridLines := EXLISTLib_TLB.exHLines;
	ScrollBySingleLine := True;
	Columns.Add('Column');
	Items.Add('Item 1');
	with Items do
	begin
		ItemHeight[Add('Item 2')] := 48;
	end;
	Items.Add('Item 3');
	Items.Add('Item 4');
end
304
How do I enable resizing all the items at runtime

with List1 do
begin
	ItemsAllowSizing := EXLISTLib_TLB.exResizeAllItems;
	DrawGridLines := EXLISTLib_TLB.exHLines;
	Columns.Add('Column');
	Items.Add('Item 1');
	with Items do
	begin
		ItemHeight[Add('Item 2')] := 48;
	end;
	Items.Add('Item 3');
end
303
How can I remove the filter

with List1 do
begin
	with (IUnknown(Columns.Add('Column')) as EXLISTLib_TLB.Column) do
	begin
		DisplayFilterButton := True;
		FilterType := EXLISTLib_TLB.exBlanks;
	end;
	ApplyFilter();
	ClearFilter();
end
302
How do I change the control's border, using your EBN files

with List1 do
begin
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Appearance := EXLISTLib_TLB.AppearanceEnum($1000000);
end
301
Can I change the style for break or divider line

with List1 do
begin
	Columns.Add('Default');
	with Items do
	begin
		Add('Item 1');
		h := Add(Null);
		ItemBreak[h] := EXLISTLib_TLB.DoubleLine;
		SelectableItem[h] := False;
		Add('Item 3');
	end;
end